<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.20"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>libxlsxwriter: Creating Excel files with C and libxlsxwriter</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="customdoxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">libxlsxwriter
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.20 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
</div><!-- top -->
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div class="PageDoc"><div class="header">
  <div class="headertitle">
<div class="title">Creating Excel files with C and libxlsxwriter </div>  </div>
</div><!--header-->
<div class="contents">
<div class="textblock"><p><b>Libxlsxwriter</b> is a C library for creating Excel XLSX files.</p>
<div class="image">
<img src="demo.png" alt=""/>
</div>
<p><a class="el" href="demo_8c-example.html">(Sample code to create the above spreadsheet.)</a></p>
<h1><a class="anchor" id="mainpage_intro"></a>
libxlsxwriter</h1>
<p>Libxlsxwriter is a C library that can be used to write text, numbers, formulas and hyperlinks to multiple worksheets in an Excel 2007+ XLSX file. It supports features such as:</p>
<ul>
<li>100% compatible Excel XLSX files.</li>
<li>Full Excel formatting.</li>
<li>Merged cells.</li>
<li>Defined names.</li>
<li>Autofilters.</li>
<li>Charts.</li>
<li>Data validation and drop down lists.</li>
<li>Conditional formatting.</li>
<li>Worksheet PNG/JPEG images.</li>
<li>Cell comments.</li>
<li>Support for adding Macros.</li>
<li>Memory optimization mode for writing large files.</li>
<li>Source code available on <a href="https://github.com/jmcnamara/libxlsxwriter">GitHub</a>.</li>
<li>FreeBSD <a class="el" href="license.html">License</a>.</li>
<li>ANSI C.</li>
<li>Works with GCC, Clang, Xcode, MSVC 2015, ICC, TCC, MinGW, MingGW-w64/32.</li>
<li>Works on Linux, FreeBSD, OpenBSD, OS X, iOS and Windows. Also works on MSYS/MSYS2 and Cygwin.</li>
<li>Compiles for 32 and 64 bit.</li>
<li>Compiles and works on big and little endian systems.</li>
<li>The only dependency is on <code>zlib</code>.</li>
</ul>
<p>This document explains how to use the libxlsxwriter library. See the following sections for more information:</p>
<ul>
<li><a class="el" href="introduction.html">Introduction</a></li>
<li><a class="el" href="getting_started.html">Getting Started with libxlsxwriter</a></li>
<li><a class="el" href="tutorial01.html">Tutorial 1: Create a simple XLSX file</a></li>
<li><a class="el" href="tutorial02.html">Tutorial 2: Adding formatting to the XLSX File</a></li>
<li><a class="el" href="tutorial03.html">Tutorial 3: Writing different types of data to the XLSX File</a></li>
<li><a class="el" href="workbook_8h.html">The Workbook object</a></li>
<li><a class="el" href="worksheet_8h.html">The Worksheet object</a></li>
<li><a class="el" href="format_8h.html">The Format object</a></li>
<li><a class="el" href="chart_8h.html">The Chart object</a></li>
<li><a class="el" href="chartsheet_8h.html">The Chartsheet object</a></li>
<li><a class="el" href="utility_8h.html">Utility functions and macros</a></li>
<li><a class="el" href="working_with_formats.html">Working with Formats</a></li>
<li><a class="el" href="working_with_colors.html">Working with Colors</a></li>
<li><a class="el" href="working_with_formulas.html">Working with Formulas</a></li>
<li><a class="el" href="working_with_dates.html">Working with Dates and Times</a></li>
<li><a class="el" href="working_with_charts.html">Working with Charts</a></li>
<li><a class="el" href="working_with_object_positioning.html">Working with Object Positioning</a></li>
<li><a class="el" href="working_with_data_validation.html">Working with Data Validation</a></li>
<li><a class="el" href="working_with_conditional_formatting.html">Working with Conditional Formatting</a></li>
<li><a class="el" href="working_with_comments.html">Working with Cell Comments</a></li>
<li><a class="el" href="working_with_outlines.html">Working with Outlines and Grouping</a></li>
<li><a class="el" href="working_with_memory.html">Working with Memory and Performance</a></li>
<li><a class="el" href="working_with_macros.html">Working with VBA Macros</a></li>
<li><a class="el" href="examples.html">Example Programs</a></li>
<li><a class="el" href="running_the_tests.html">Running the Test Suite</a></li>
<li><a class="el" href="faq.html">Frequently Asked Questions</a></li>
<li><a class="el" href="bugs.html">Known Issues and Bugs</a></li>
<li><a class="el" href="author.html">Author</a></li>
<li><a class="el" href="license.html">License</a></li>
<li><a class="el" href="changes.html">Changes</a> </li>
</ul>
</div></div><!-- PageDoc -->
</div><!-- contents -->
<!-- HTML footer for doxygen 1.8.20-->
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Copyright 2014-2020 John McNamara.
Generated by&#160;<a href="http://www.doxygen.org/index.html"><img class="footer" src="doxygen.svg" width="104" height="31" alt="doxygen"/></a> 1.8.20
</small></address>
</body>
</html>
